Install PostgreSQL
2015/01/15 |
Install PostgreSQL to configure database server.
|
|
[1] | Install PostgreSQL. |
[root@www ~]#
[root@www ~]# yum -y install postgresql-server /etc/rc.d/init.d/postgresql initdb Initializing database: [ OK ]
[root@www ~]#
vi /var/lib/pgsql/data/postgresql.conf # line 59: uncomment and change (listen all) listen_addresses = ' * '
# line 33: uncomment and change (change log format) log_line_prefix = ' %t %u %d '
/etc/rc.d/init.d/postgresql start Starting postgresql service: [ OK ] [root@www ~]# chkconfig postgresql on
|
[2] | Set admin user's password and add a user. |
# switch to postgres user and set password [root@www ~]# su - postgres -bash-4.1$ psql -c "alter user postgres with password 'password'" ALTER ROLE # add a user "cent" -bash-4.1$ createuser cent Shall the new role be a superuser? (y/n) y # set privileges if you want |
[3] | Login with a user just created and make sure basic DB operations. |
# create a test DB [cent@www ~]$ createdb testdb [cent@www ~]$ psql -l # confirm List of databases Name | Owner | Encoding | Collation | Ctype | Access privileg es -----------+----------+----------+-------------+-------------+------------------ ----- postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres testdb | cent | UTF8 | en_US.UTF-8 | en_US.UTF-8 | (4 rows) # connect to the test DB [cent@www ~]$ psql testdb
psql (8.4.20)
Type "help" for help. # set password testdb=# alter user cent with password 'password'; ALTER ROLE # create a test table testdb=# create table test ( no int,name text ); CREATE TABLE # insert test data testdb=# insert into test (no,name) values (1,'cent'); INSERT 0 1 # confirm testdb=# select * from test;
no | name ----+------- 1 | cent (1 row) # remove test table testdb=# drop table test; DROP TABLE # quit testdb=# \q
# remobe test DB [cent@www ~]$ dropdb testdb
|